publicholiday

Table: publicholiday

The publicholiday table stores information about official public holidays.
It is used to manage holiday schedules and track related metadata.

---

Columns

Column Name	Data Type	Constraints	Description
publicHolidayId	int(11)	NOT NULL, PRIMARY KEY, AUTO_INCREMENT	Unique identifier for each public holiday
createdDate	datetime	DEFAULT NULL	Timestamp when the record was created
startDate	date	DEFAULT NULL	Start date of the public holiday
holidayReason	varchar(30)	DEFAULT NULL	Reason for the holiday
holidayType	varchar(30)	DEFAULT NULL	Type or category of the holiday
lastEditedDate	datetime	DEFAULT NULL	Timestamp when the record was last edited
createdByUserId	int(11)	DEFAULT NULL	User who created the record
editedByUserId	int(11)	DEFAULT NULL	User who last edited the record
voided	int(11)	DEFAULT '0'	Flag indicating if the holiday is voided (1) or active (0)
endDate	date	DEFAULT NULL	End date of the public holiday
locationId	int(11)	DEFAULT NULL	Location associated with the holiday

---

Indexes

1. PRIMARY - Primary key on publicHolidayId
2. publicholiday_editedByUserId_fk - Index on editedByUserId
3. publicholiday_createdByUserId_fk - Index on createdByUserId
4. ph_locationId_location_locationId_FK - Index on locationId

---

Foreign Key Relations

createdByUserId → user.mappedId

editedByUserId → user.mappedId

locationId → location.locationId

---

Usage Notes

• Tracks public holidays for scheduling and reporting purposes.
• startDate and endDate define the holiday duration.
• voided indicates inactive or canceled holidays.
• Linked to location and user tables for contextual information.